Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MSSQL Tutorial
1) Aggregate Functions
2) Analytical Functions
3) CLR
4) Constraints
5) Cursor
6) Data Convert Functions
7) Data Types
8) Database
9) Date Functions
10) Index
11) Insert Delete Update
12) Math Functions
13) Procedure Function
14) Query
15) Sequence Indentity
16) Set Operations
17) String Functions
18) Subquery
19) System Functions
20) System Settings
21) System Tables Views
22) Table
23) Table Join
24) Transact SQL
25) Transaction
26) Trigger
27) User Role
28) View
29) XML

Procedure Function
1) A CREATE PROC statement that includes three parameters
2) A CREATE PROC statement that uses an input and an output parameter
3) A CREATE PROC statement that uses an optional parameter
4) A script that creates a stored procedure that copies a table
5) A SELECT statement that uses the function in a join operation
6) A statement that creates a scalar-valued function
7) A statement that creates a simple table-valued function
8) A stored procedure that tests for a valid foreign key
9) ALTER a FUNCTION to mark with SCHEMABINDING
10) ALTER PROC Statement Using WITH RECOMPILE
11) Call procedure with parameter name
12) Call two user-defined functions in a select statement
13) Call user-defined function in where clause
14) Calling a Stored Procedure
15) Calls the procedure
16) Changing Character Values to Proper Case with user-defined functions
17) Check parameter value with if statement
18) Check the existance of a function
19) Check value range for input parameter
20) Code that omits both optional parameters
21) Code that omits one optional parameter
22) Code that passes the parameters by name
23) Code that passes the parameters by position
24) Create a scalar-valued function that returns the total Billing amount due
25) CREATE PROCEDURE Syntax
26) Create procedure to drop foreign key
27) Creating a Stored Procedure
28) Creating a User-Defined Function
29) Declare a variable in a procedure
30) DROP PROCPROCEDURE sproc name
31) Encrypting a Stored Procedure
32) Execute as
33) Filtering for Null Values with a Stored Procedure
34) Format a date
35) Function WITH SCHEMABINDING
36) Get the 3 employees with the most RegionPlace
37) delete or change a stored procedure
38) If an int odd
39) Implementing the fibonacci() User-Defined Function with Recursion
40) Implementing the fibonacci2() User-Defined Function with a Loop
41) Invoke the scalar-valued function
42) Iterative solution does not have the restriction 32 nesting levels
43) Linear_max() Scalar Function
44) Managing a Transaction Inside a Stored Procedure
45) Modifying a Stored Procedure
46) Multi-Statement Table-Valued Functions
47) Nesting Stored Procedures
48) Parameter for passing value out of a procedure
49) Parameter with null default value
50) Parameterization
51) Parameters can be passed explicitly by value
52) Pass a declared variable to a function
53) Pass column as the parameter
54) Passing the ORDER BY Column as a Parameter, Using a Column Number
55) Passing the ORDER BY Column as a Parameter, Using Dynamic Execution
56) PRINT information out of a PROCEDURE
57) Procedure as a view
58) Procedure with default parameter value
59) Procedure with two parameters
60) Query a table returned from a function
61) Recursive procedure with output parameter
62) Recursively call itself
63) Return a value out of a procedure
64) Return TOP 100 PERCENT WITH TIES from a function
65) Return with aggregate function
66) Return with case statement
67) Returning Values from a View as Stored Procedure Output Parameters
68) Scalar Functions
69) Scalar functions are functions that return a single value
70) Select using value from parameter
71) Spelling single digits
72) Stored procedure can be executed with the parameter and assigned value
73) Stored procedure returning value using an Output parameter
74) Stored Procedure with Cursor Parameter
75) Stored Procedures as Parameterized Views
76) Syntax for Creating Inline Table-Valued Functions
77) Syntax for Creating Multistatement Table-Valued Functions
78) The linear_min Scalar Function
79) The syntax for altering a multi-statement table-valued function
80) The syntax for altering a simple table-valued function
81) The syntax for creating a multi-statement table-valued function
82) The syntax for creating a scalar-valued function
83) The syntax for creating a simple table-valued function
84) The syntax for declaring parameters
85) The syntax of the ALTER FUNCTION statement for a scalar valued function
86) The syntax of the ALTER PROC statement
87) The syntax of the DROP FUNCTION statement
88) UDFs Returning a Scalar Value
89) Use function as a view
90) Use function to wrap a long sql statement
91) Uses system tables to determine the datatype of a field
92) Using EXECUTE AS to Specify the Procedures Security Context
93) Using WITH RECOMPILE
94) Wildcards in Parameters